Categories of Oracle RAC Interview Questions
Ans: Oracle RAC consists of a database that is represented in a clustered manner in the architecture. The cluster is the collection or pool of independent servers that make up one single system.
Cluster architecture provides more flexibility to manage and follow a modular incremental approach to improve fault errors and provide an incremental system.
This architecture provides maximum security in terms of ensuring the high availability of the resources to the users.
It provides the resources on-demand and provides hardware architecture such as failure at a single point is being removed.
The architecture provides the decoupling of the Oracle instance like the process and memory that are running on the server from the Oracle database.
Ans: Oracle Real Application (RAC) provides the interaction of executable file with the Oracle database.
It allows the running of any packaged or custom-built application with Oracle DB that is running on a server pool. It provides a very high level of availability, flexibility, and scalability to run the application and store it to the database.
It creates the database such that if the pool fails then the database is continued to run from the remaining servers and the load can be distributed. It makes it easier for the administrator to maintain many servers at the same time by load-balancing techniques and providing provision to add more and more servers when the load increases.
Ans: When an instance crashes in a single node database on startup a crash recovery takes place. In a RAC environment, the same recovery for an instance is performed by the surviving nodes called Instance recovery.
Inclined to build a profession as Oracle RAC? Then here is the blog post on, explore "Oracle RAC Training"
Ans: A private N/W is used to ship data blocks from one instance to another for cache fusion. The physical data blocks as well as data dictionary blocks are shared across this interconnect.
Ans: One of the ways is to look at the DB alert log for the time period when the DB was started up.
Ans: Either the Network Time Protocol(NTP) can be configured or in 11gr2, Cluster Time Synchronization Service (CTSS) can be used.
Ans: Spfiles, ControlFiles, Datafiles, and Redolog files should be created.
Ans: The OCR config -show backup can be run to find out the automatic and manually run backups.
Ans: You can use either the logical or the physical OCR backup copy to restore the Repository.
Ans: You can use the dba_hist_seg_stats.
Ans: The VIP is an alternate Virtual IP address assigned to each node in a cluster. During a node failure, the VIP of the failed node moves to the surviving node and relays to the application that the node has gone down. Without VIP, the application will wait for TCP timeout and then find out that the session is no longer live due to the failure.
Ans: You can query the V$ACTIVE_INSTANCES view to determine the member instances of the RAC cluster.
Ans: The Cluster Health Monitor (CHM) stores operating system metrics in the CHM repository for all nodes in a RAC cluster. It stores information on CPU, memory, process, network and other OS data, This information can later be retrieved and used to troubleshoot and identify any cluster related issues. It is a default component of the 11gr2 grid install. The data is stored in the master repository and replicated to a standby repository on a different node.
Ans: All processing will showdown to the CPU speed of the slowest server.
Ans: In 10g the default SGA size is 1G in 11g it is set to 256M and in 12c ASM it is set back to 1G.
Ans: You can use md_backup to restore the ASM disk group configuration in-case of ASM disk group storage loss.
Ans:
Ans: This is the parameter that controls the number of Allocation units the ASM instance will try to rebalance at any given time. In ASM versions less than 11.2.0.3 the default value is 11 however it has been changed to unlimited in later versions.
Ans: A patch is considered a rolling if it is can be applied to the cluster binaries without having to shut down the database in a RAC environment. All nodes in the cluster are patched in a rolling manner, one by one, with only the node which is being patched unavailable while all other instances open.
Ans: Some of the RAC parameters are:
Ans: The Grid software is becoming more and more capable of not just supporting HA for Oracle Databases but also other applications including Oracle’s applications. With 12c there are more features and functionality built-in and it is easier to deploy these pre-built solutions, available for common Oracle applications.
Ans: The backups should include OLR, OCR, and ASM Metadata.
Ans: You can run the opatch lsinventory -all_nodes command from a single node to look at the inventory details for all nodes in the cluster.
Ans: In a RAC environment, it is the combining of data blocks, which are shipped across the interconnect from remote database caches (SGA) to the local node, in order to fulfill the requirements for a transaction (DML, Query of Data Dictionary).
Ans: When database nodes in a cluster are unable to communicate with each other, they may continue to process and modify the data blocks independently. If the same block is modified by more than one instance, synchronization/locking of the data blocks does not take place and blocks may be overwritten by others in the cluster. This state is called split-brain.
Ans: Load balancing advisory is a process through which the load of the applications and resources can be managed throughout the servers.
It monitors the workload of the current activities from all the clusters and the instances that is being given on the server.
The service that is being provided is active all the time to see the workload of the applications on the servers. To simplify it, it provides a percentage value to show the total workload of the instance and it flags the instance according to the quality.
Load Balancing Advisory helps in maintaining the loads from the servers and equally distributes it among many other servers that are not currently working.
Ans: Cluster Verification Utility is a tool in the Oracle Grid that is used to eliminate the errors that come up with the validations of the steps.
It provides verification of the changes that are being made in the configuration of the files or the system.
The tool can be used with the command-line interface and it is used to validate the configuration input as well such that during the installation it can be found out that everything is perfectly ok.
The tool is used to verify the system pre-requisites that are related to Oracle Clusterware, ASM, and the databases.
There are few fix-up scripts available if by any means the verification tool fails then these scripts can be used to automatically fix the errors.
Ans: Oracle RAC uses a single system in the form of an image to configure and manage the servers in an easy way. It provides a database for the installed and configured applications from one location so that it can be managed in an easy way.
The components required to be provided with it is as follows:
You liked the article?
Like: 1
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
